using System;
using System.Collections.Generic;
using System.Text;

namespace SC.CodeBuilder
{
    public class BuilderDALParamDataType_aaaaaaaaaaaaaaa
    {
        private static string RetrunType;
        public static string ConvertType(string Type)
        {
            switch (Type.Trim())
            {
                case "char": RetrunType = "Char"; break;
                case "varchar": RetrunType = "VarChar"; break;
                case "text": RetrunType = "Text"; break;
                case "datetime": RetrunType = "DateTime"; break;
                case "smdlldatetime": RetrunType = "SmdllDateTime"; break;
                case "nchar": RetrunType = "NChar"; break;
                case "nvarchar": RetrunType = "NVarChar"; break;
                case "ntext": RetrunType = "NText"; break;
                case "binary": RetrunType = "Binary"; break;
                case "varbinary": RetrunType = "VarBinary"; break;
                case "image": RetrunType = "Image"; break;
                case "bit": RetrunType = "Bit"; break;
                case "tinyint": RetrunType = "TinyInt"; break;
                case "smallint": RetrunType = "SmallInt"; break;
                case "int": RetrunType = "Int"; break;
                case "bigint": RetrunType = "BigInt"; break;
                case "numeric": RetrunType = "Decimal"; break;
                case "decimal": RetrunType = "Decimal"; break;
                case "int identity": RetrunType = "Int"; break;
                case "smallmoney": RetrunType = "SmallMoney"; break;
                case "money": RetrunType = "Money"; break;
                case "float": RetrunType = "Float"; break;
                case "real": RetrunType = "Real"; break;
                default: RetrunType = "1"; break;
            }
            return RetrunType;
        }
    }
}
